Examples of Forecast Calculations

A set of examples may help demonstrate how forecast calculations are performed in Cobra.

Assume that you have budgeted 1000 hours for a work package scheduled to start in January and finish in May as follows:

Jan Feb Mar Apr May
150.00 450.00 200.00 100.00 100.00

At the end of the first month you advance the status date one period, and indicate that 10% of the work has been completed. You calculate and post an earned value of 100 hours for the work package, and enter actual costs of 200 hours.

At this point, we can see how Cobra calculates four different types of forecasts, based on the following methods:
  • PF=1
  • PF=User input
  • Manual Forecast (Retain EAC)
  • Manual Forecast (Retain ETC)

PF=1

Cobra recalculates the work package ETC by subtracting any earned portion from the original budget and assuming that any remaining work will be performed according to the budget. This results in a forecast ETC of 900 hours and a forecast EAC of 1100 hours (ETC plus actual costs). Cobra then prorates this new ETC over the remaining periods for the work package as follows:

Feb Mar Apr May
476.46 211.78 105.88 105.88

PF=User input

In this case, Cobra uses a user-defined performance factor of 0.9, which indicates that the remaining work is expected to be performed at 90% of the cost of the original budget. This performance factor results in a forecast ETC of 810 hours for the work package and a forecast EAC of 1010 hours. Cobra spreads this ETC as follows:

Feb Mar Apr May
428.81 190.59 95.30 95.30

Manual Forecast (Retain EAC)

When generating manual forecasts, Cobra ignores any value earned by the work package. With this method, the previous EAC (1000 hours) is retained and a new ETC is calculated by subtracting the actual costs (200 hours) from that figure. The result is a forecast ETC of 800 hours, which is initially spread as follows:

Feb Mar Apr May
423.52 188.24 94.12 94.12

Manual Forecast (Retain ETC)

For this method of generating forecasts, Cobra simply looks at the remaining ETC of the work package and adds any actual costs already incurred. In this example, the calculation results in an EAC of 1050 hours (850 hours of remaining budget plus 200 hours of actuals).

Feb Mar Apr May
450.00 200.00 100.00 100.00